Re: total db lockup

actually, I'm using postgresql 7.3.2. I noticed there were some hash index fixes in 7.4, so that might be it. Would
therebe any other reason for this deadlock? This database has been in production for almost 2 years and this is the
firsttime we've seen the problem. 

thanks,

Eugene


>
> From: Alvaro Herrera <alvherre@alvh.no-ip.org>
> Date: 2005/08/19 Fri AM 11:22:04 EST
> To: Eugene <eugene1@sympatico.ca>
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] total db lockup
>
> On Fri, Aug 19, 2005 at 10:54:35AM -0400, Eugene wrote:
> > Thanks Alvaro.
> >
> > Here it is again:
> >
> > problem description:            http://rafb.net/paste/results/bLAtIk26.html
> > db state before first restart:  http://rafb.net/paste/results/D1Bqe125.html
> > db state before second restart: http://rafb.net/paste/results/D1Bqe125.html
> > table definition:               http://rafb.net/paste/results/W35ccD49.html
>
> Ok, so it seems the lockup occured only with the hash indexes?  Then it
> means we still have bugs in the locking code for those.  It doesn't
> surprise me.  There's a reason they are not recommended, you know?
>
> Let us know if you find the problem showing up again with btree indexes.
> The hash indexes bugs should be fixed, but they are not high priority ...
>
> --
> Alvaro Herrera (<alvherre[a]alvh.no-ip.org>)
> "If it wasn't for my companion, I believe I'd be having
> the time of my life"  (John Dunbar)
>